﻿CREATE TABLE [dbo].[t_Loan_Verification] (
    [LoanID]                INT             NOT NULL,
    [VerificationID]        INT             NOT NULL,
    [ParentID]              INT             NULL,
    [Lable]                 NVARCHAR (128)  NULL,
    [Checked]               BIT             NOT NULL,
    [Pos]                   TINYINT         NULL,
    [MenuID]                INT             NULL,
    [CommentToBroker]       VARCHAR (2000)  NULL,
    [CommentToManager]      VARCHAR (2000)  NULL,
    [CommentFromBroker]     VARCHAR (2000)  NULL,
    [CommentToVerifier]     VARCHAR (2000)  NULL,
    [CommentToVerifierHist] VARCHAR (7000)  NULL,
    [CommentToSelf]         VARCHAR (1024)  NULL,
    [CommentToManager_Date] SMALLDATETIME   NULL,
    [ManagerTo]             NVARCHAR (128)  NULL,
    [IsParent]              BIT             NOT NULL,
    [IsCustom]              BIT             NOT NULL,
    [Owner]                 NVARCHAR (128)  NULL,
    [Description]           NVARCHAR (2000) NULL,
    [DateStamp]             DATETIME        NULL
);

